<?php

include('includes/session.inc');

$Title = _('Change Asset Location');

$ViewTopic = 'FixedAssets';
$BookMark = 'AssetTransfer';
include('includes/header.inc');

echo '<p class="page_title_text noPrint" ><img src="' . $RootPath . '/css/' . $Theme . '/images/magnifier.png" title="' . _('Search') . '" alt="" />' . ' ' . $Title . '</p>';

foreach ($_POST as $AssetToMove => $Value) { //Value is not used?
	if (mb_substr($AssetToMove, 0, 4) == 'Move') { // the form variable is of the format MoveAssetID so need to strip the move bit off
		$AssetID = mb_substr($AssetToMove, 4);
		if (isset($_POST['Location' . $AssetID]) and $_POST['Location' . $AssetID] != '') {
			$sql = "UPDATE fixedassets
						SET assetlocation='" . $_POST['Location' . $AssetID] . "'
						WHERE assetid='" . $AssetID . "'";

			$result = DB_query($sql, $db);
			prnMsg(_('The Fixed Asset has been moved successfully'), 'success');
			echo '<br />';
		}
	}
}

if (isset($_GET['AssetID'])) {
	$AssetID = $_GET['AssetID'];
} else if (isset($_POST['AssetID'])) {
	$AssetID = $_POST['AssetID'];
} else {
	$sql = "SELECT categoryid, categorydescription FROM fixedassetcategories";
	$result = DB_query($sql, $db);
	echo '<form onSubmit="return VerifyForm(this);" action="' . htmlspecialchars($_SERVER['PHP_SELF'], ENT_QUOTES, 'UTF-8') . '" method="post" class="noPrint">';
	echo '<div>';
	echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />';

	echo '<table class="selection"><tr>';
	echo '<td>' . _('In Asset Category') . ': </td>';
	echo '<td><select minlength="0" name="AssetCat">';

	if (!isset($_POST['AssetCat'])) {
		$_POST['AssetCat'] = '';
	}

	while ($myrow = DB_fetch_array($result)) {
		if ($myrow['categoryid'] == $_POST['AssetCat']) {
			echo '<option selected="selected" value="' . $myrow['categoryid'] . '">' . $myrow['categorydescription'] . '</option>';
		} else {
			echo '<option value="' . $myrow['categoryid'] . '">' . $myrow['categorydescription'] . '</option>';
		}
	}

	echo '</select></td>';
	echo '<td>' . _('Enter partial') . '<b> ' . _('Description') . '</b>:</td><td>';


	if (isset($_POST['Keywords'])) {
		echo '<input type="text" autofocus="autofocus" name="Keywords" value="' . trim($_POST['Keywords'], '%') . '" size="20" minlength="0" maxlength="25" />';
	} else {
		echo '<input type="text" autofocus="autofocus" name="Keywords" size="20" minlength="0" maxlength="25" />';
	}

	echo '</td>
		</tr>
		<tr>
			<td>' . _('Asset Location') . ':</td>
			<td><select minlength="0" name="AssetLocation">';
	if (!isset($_POST['AssetLocation'])) {
		$_POST['AssetLocation'] = 'ALL';
	}
	if ($_POST['AssetLocation'] == 'ALL') {
		echo '<option selected="selected" value="ALL">' . _('Any asset location') . '</option>';
	} else {
		echo '<option value="ALL">' . _('Any asset location') . '</option>';
	}
	$result = DB_query("SELECT locationid, locationdescription FROM fixedassetlocations", $db);

	while ($myrow = DB_fetch_array($result)) {
		if ($myrow['locationid'] == $_POST['AssetLocation']) {
			echo '<option selected="selected" value="' . $myrow['locationid'] . '">' . $myrow['locationdescription'] . '</option>';
		} else {
			echo '<option value="' . $myrow['locationid'] . '">' . $myrow['locationdescription'] . '</option>';
		}
	}
	echo '</select>';


	echo '<td><b>' . _('OR') . ' ' . '</b>' . _('Enter partial') . ' <b>' . _('Asset Code') . '</b>:</td>';
	echo '<td>';

	if (isset($_POST['AssetID'])) {
		echo '<input type="text" name="AssetID" value="' . trim($_POST['AssetID'], '%') . '" size="15" minlength="0" maxlength="40" />';
	} else {
		echo '<input type="text" name="AssetID" size="15" minlength="0" maxlength="40" />';
	}

	echo '</td></tr></table><br />';

	echo '<div class="centre"><input type="submit" name="Search" value="' . _('Search Now') . '" /></div>
		  </div>
		  </form>
		  <br />';
}

if (isset($_POST['Search'])) {

	if ($_POST['AssetLocation'] == 'ALL') {
		$AssetLocation = '%';
	} else {
		$AssetLocation = '%' . $_POST['AssetLocation'] . '%';
	}
	if ($_POST['AssetCat'] == 'All') {
		$AssetID = '%';
	}
	if (isset($_POST['Keywords'])) {
		$Keywords = '%' . $_POST['Keywords'] . '%';
	} else {
		$Keywords = '%';
	}
	if (isset($_POST['AssetID'])) {
		$AssetID = '%' . $_POST['AssetID'] . '%';
	} else {
		$AssetID = '%';
	}


	$sql = "SELECT fixedassets.assetid,
				fixedassets.cost,
				fixedassets.accumdepn,
				fixedassets.description,
				fixedassets.depntype,
				fixedassets.serialno,
				fixedassets.barcode,
				fixedassets.assetlocation as ItemAssetLocation,
				fixedassetlocations.locationdescription
			FROM fixedassets
			INNER JOIN fixedassetlocations
			ON fixedassets.assetlocation=fixedassetlocations.locationid
			WHERE fixedassets.assetcategoryid " . LIKE . "'" . $_POST['AssetCat'] . "'
			AND fixedassets.description " . LIKE . "'" . $Keywords . "'
			AND fixedassets.assetid " . LIKE . "'" . $AssetID . "'
			AND fixedassets.assetlocation " . LIKE . "'" . $AssetLocation . "'
			ORDER BY fixedassets.assetid";


	$Result = DB_query($sql, $db);
	echo '<br />';
	echo '<form onSubmit="return VerifyForm(this);" action="' . htmlspecialchars($_SERVER['PHP_SELF'], ENT_QUOTES, 'UTF-8') . '" method="post" class="noPrint">
		  <div>';
	echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />';
	echo '<table class="selection">';
	echo '<tr>
			<th>' . _('Asset ID') . '</th>
			<th>' . _('Description') . '</th>
			<th>' . _('Serial number') . '</th>
			<th>' . _('Purchase Cost') . '</th>
			<th>' . _('Total Depreciation') . '</th>
			<th>' . _('Current Location') . '</th>
			<th colspan="2">' . _('Move To') . '</th>
		</tr>';

	$locationsql = "SELECT locationid, locationdescription from fixedassetlocations";
	$LocationResult = DB_query($locationsql, $db);

	while ($myrow = DB_fetch_array($Result)) {

		echo '<tr>
				<td>' . $myrow['assetid'] . '</td>
				<td>' . $myrow['description'] . '</td>
				<td>' . $myrow['serialno'] . '</td>
				<td class="number">' . locale_number_format($myrow['cost'], $_SESSION['CompanyRecord']['decimalplaces']) . '</td>
				<td class="number">' . locale_number_format($myrow['accumdepn'], $_SESSION['CompanyRecord']['decimalplaces']) . '</td>
				<td>' . $myrow['ItemAssetLocation'] . '</td>';
		echo '<td><select minlength="0" name="Location' . $myrow['assetid'] . '" onchange="ReloadForm(Move' . $myrow['assetid'] . ')">';
		$ThisDropDownName = 'Location' . $myrow['assetid'];
		while ($LocationRow = DB_fetch_array($LocationResult)) {

			if (isset($_POST[$ThisDropDownName]) and ($_POST[$ThisDropDownName] == $LocationRow['locationid'])) {
				echo '<option selected="selected" value="' . $LocationRow['locationid'] . '">' . $LocationRow['locationdescription'] . '</option>';
			} elseif ($LocationRow['locationid'] == $myrow['ItemAssetLocation']) {
				echo '<option selected="selected" value="' . $LocationRow['locationid'] . '">' . $LocationRow['locationdescription'] . '</option>';
			} else {
				echo '<option value="' . $LocationRow['locationid'] . '">' . $LocationRow['locationdescription'] . '</option>';
			}
		}
		DB_data_seek($LocationResult, 0);
		echo '</select></td>';
		echo '<input type="hidden" name="AssetCat" value="' . $_POST['AssetCat'] . '" />';
		echo '<input type="hidden" name="AssetLocation" value="' . $_POST['AssetLocation'] . '" />';
		echo '<input type="hidden" name="Keywords" value="' . $_POST['Keywords'] . '" />';
		echo '<input type="hidden" name="AssetID" value="' . $_POST['AssetID'] . '" />';
		echo '<input type="hidden" name="Search" value="' . $_POST['Search'] . '" />';
		echo '<td><input type="submit" name="Move' . $myrow['assetid'] . '" value="Move" /></td>';
		echo '</tr>';
	}
	echo '</table>
		  </div>
		  </form>';
}

include('includes/footer.inc');

?>